Living Economies, Aotearoa/New Zealand

Error

An error occured in a database query!

Context:
File	/tiki-view_forum.php
Url	/tiki-view_forum.php?forumId=&comments_postComment=post&comments_title=BasicMisconceptions&comments_data=Use%20this%20thread%20to%20discuss%20the%20[tiki-index.php?page=BasicMisconceptions\|BasicMisconceptions%5D%20page.&comment_topictype=n
Query:
select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`, a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`, a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`, a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`, IFNULL(max(b.`commentDate`), a.`commentDate`) as `lastPost`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where a.`object`=? and a.`type` = ? and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating` order by , `threadId`
Values:
0
1	s
2	0
Message:
Error Message	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `threadId` LIMIT 0,0' at line 10

Go back

Return to home page

Visitor's Map

array(3) { [0]=> array(7) { ["file"]=> string(43) "/home/ttnz/public_html/le/lib/tikidblib.php" ["line"]=> int(84) ["function"]=> string(9) "sql_error" ["class"]=> string(6) "TikiDB" ["object"]=> object(Comments)#23 (11) { ["time_control"]=> int(0) ["db"]=> object(ADODB_mysql)#2 (78) { ["databaseType"]=> string(5) "mysql" ["dataProvider"]=> string(5) "mysql" ["hasInsertID"]=> bool(true) ["hasAffectedRows"]=> bool(true) ["metaTablesSQL"]=> string(11) "SHOW TABLES" ["metaColumnsSQL"]=> string(20) "SHOW COLUMNS FROM %s" ["fmtTimeStamp"]=> string(13) "'Y-m-d H:i:s'" ["hasLimit"]=> bool(true) ["hasMoveFirst"]=> bool(true) ["hasGenID"]=> bool(true) ["isoDates"]=> bool(true) ["sysDate"]=> string(9) "CURDATE()" ["sysTimeStamp"]=> string(5) "NOW()" ["hasTransactions"]=> bool(false) ["forceNewConnect"]=> bool(false) ["poorAffectedRows"]=> bool(true) ["clientFlags"]=> int(0) ["substr"]=> string(9) "substring" ["nameQuote"]=> string(1) "`" ["_genIDSQL"]=> string(38) "update %s set id=LAST_INSERT_ID(id+1);" ["_genSeqSQL"]=> string(33) "create table %s (id int not null)" ["_genSeq2SQL"]=> string(26) "insert into %s values (%s)" ["_dropSeqSQL"]=> string(13) "drop table %s" ["database"]=> string(2) "le" ["host"]=> string(9) "localhost" ["user"]=> string(2) "le" ["password"]=> string(8) "bootlace" ["debug"]=> bool(false) ["maxblobsize"]=> int(262144) ["concat_operator"]=> string(1) "+" ["length"]=> string(6) "length" ["random"]=> string(6) "rand()" ["upperCase"]=> string(5) "upper" ["fmtDate"]=> string(7) "'Y-m-d'" ["true"]=> string(1) "1" ["false"]=> string(1) "0" ["replaceQuote"]=> string(2) "\'" ["charSet"]=> bool(false) ["metaDatabasesSQL"]=> string(0) "" ["uniqueOrderBy"]=> bool(false) ["emptyDate"]=> string(6) " " ["emptyTimeStamp"]=> string(6) " " ["lastInsID"]=> bool(false) ["hasTop"]=> bool(false) ["readOnly"]=> bool(false) ["genID"]=> int(0) ["raiseErrorFn"]=> string(16) "ADODB_Error_PEAR" ["cacheSecs"]=> int(3600) ["arrayClass"]=> string(18) "ADORecordSet_array" ["noNullStrings"]=> bool(false) ["numCacheHits"]=> int(0) ["numCacheMisses"]=> int(0) ["pageExecuteCountRows"]=> bool(true) ["uniqueSort"]=> bool(false) ["leftOuter"]=> bool(false) ["rightOuter"]=> bool(false) ["ansiOuter"]=> bool(false) ["autoRollback"]=> bool(false) ["fnExecute"]=> bool(false) ["fnCacheExecute"]=> bool(false) ["blobEncodeType"]=> bool(false) ["rsPrefix"]=> string(13) "ADORecordSet_" ["autoCommit"]=> bool(true) ["transOff"]=> int(0) ["transCnt"]=> int(0) ["fetchMode"]=> bool(false) ["_oldRaiseFn"]=> bool(false) ["_transOK"]=> NULL ["_connectionID"]=> resource(17) of type (mysql link) ["_errorMsg"]=> string(168) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `threadId` LIMIT 0,0' at line 10" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(2) "le" } ["buffer"]=> NULL ["flag"]=> NULL ["parser"]=> NULL ["pre_handlers"]=> array(0) { } ["pos_handlers"]=> array(0) { } ["postedit_handlers"]=> array(0) { } ["usergroups_cache"]=> array(0) { } ["num_queries"]=> int(0) ["now"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &string(825) "select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`, a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`, a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`, a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`, IFNULL(max(b.`commentDate`), a.`commentDate`) as `lastPost`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where a.`object`=? and a.`type` = ? and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating` order by , `threadId`" [1]=> &array(3) { [0]=> string(0) "" [1]=> string(1) "s" [2]=> int(0) } [2]=> &bool(false) } } [1]=> array(7) { ["file"]=> string(45) "/home/ttnz/public_html/le/lib/commentslib.php" ["line"]=> int(577) ["function"]=> string(5) "query" ["class"]=> string(6) "TikiDB" ["object"]=> object(Comments)#23 (11) { ["time_control"]=> int(0) ["db"]=> object(ADODB_mysql)#2 (78) { ["databaseType"]=> string(5) "mysql" ["dataProvider"]=> string(5) "mysql" ["hasInsertID"]=> bool(true) ["hasAffectedRows"]=> bool(true) ["metaTablesSQL"]=> string(11) "SHOW TABLES" ["metaColumnsSQL"]=> string(20) "SHOW COLUMNS FROM %s" ["fmtTimeStamp"]=> string(13) "'Y-m-d H:i:s'" ["hasLimit"]=> bool(true) ["hasMoveFirst"]=> bool(true) ["hasGenID"]=> bool(true) ["isoDates"]=> bool(true) ["sysDate"]=> string(9) "CURDATE()" ["sysTimeStamp"]=> string(5) "NOW()" ["hasTransactions"]=> bool(false) ["forceNewConnect"]=> bool(false) ["poorAffectedRows"]=> bool(true) ["clientFlags"]=> int(0) ["substr"]=> string(9) "substring" ["nameQuote"]=> string(1) "`" ["_genIDSQL"]=> string(38) "update %s set id=LAST_INSERT_ID(id+1);" ["_genSeqSQL"]=> string(33) "create table %s (id int not null)" ["_genSeq2SQL"]=> string(26) "insert into %s values (%s)" ["_dropSeqSQL"]=> string(13) "drop table %s" ["database"]=> string(2) "le" ["host"]=> string(9) "localhost" ["user"]=> string(2) "le" ["password"]=> string(8) "bootlace" ["debug"]=> bool(false) ["maxblobsize"]=> int(262144) ["concat_operator"]=> string(1) "+" ["length"]=> string(6) "length" ["random"]=> string(6) "rand()" ["upperCase"]=> string(5) "upper" ["fmtDate"]=> string(7) "'Y-m-d'" ["true"]=> string(1) "1" ["false"]=> string(1) "0" ["replaceQuote"]=> string(2) "\'" ["charSet"]=> bool(false) ["metaDatabasesSQL"]=> string(0) "" ["uniqueOrderBy"]=> bool(false) ["emptyDate"]=> string(6) " " ["emptyTimeStamp"]=> string(6) " " ["lastInsID"]=> bool(false) ["hasTop"]=> bool(false) ["readOnly"]=> bool(false) ["genID"]=> int(0) ["raiseErrorFn"]=> string(16) "ADODB_Error_PEAR" ["cacheSecs"]=> int(3600) ["arrayClass"]=> string(18) "ADORecordSet_array" ["noNullStrings"]=> bool(false) ["numCacheHits"]=> int(0) ["numCacheMisses"]=> int(0) ["pageExecuteCountRows"]=> bool(true) ["uniqueSort"]=> bool(false) ["leftOuter"]=> bool(false) ["rightOuter"]=> bool(false) ["ansiOuter"]=> bool(false) ["autoRollback"]=> bool(false) ["fnExecute"]=> bool(false) ["fnCacheExecute"]=> bool(false) ["blobEncodeType"]=> bool(false) ["rsPrefix"]=> string(13) "ADORecordSet_" ["autoCommit"]=> bool(true) ["transOff"]=> int(0) ["transCnt"]=> int(0) ["fetchMode"]=> bool(false) ["_oldRaiseFn"]=> bool(false) ["_transOK"]=> NULL ["_connectionID"]=> resource(17) of type (mysql link) ["_errorMsg"]=> string(168) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `threadId` LIMIT 0,0' at line 10" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(2) "le" } ["buffer"]=> NULL ["flag"]=> NULL ["parser"]=> NULL ["pre_handlers"]=> array(0) { } ["pos_handlers"]=> array(0) { } ["postedit_handlers"]=> array(0) { } ["usergroups_cache"]=> array(0) { } ["num_queries"]=> int(0) ["now"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> &string(825) "select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`, a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`, a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`, a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`, IFNULL(max(b.`commentDate`), a.`commentDate`) as `lastPost`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where a.`object`=? and a.`type` = ? and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating` order by , `threadId`" [1]=> &array(3) { [0]=> string(0) "" [1]=> string(1) "s" [2]=> int(0) } [2]=> &NULL [3]=> &int(0) } } [2]=> array(7) { ["file"]=> string(45) "/home/ttnz/public_html/le/tiki-view_forum.php" ["line"]=> int(707) ["function"]=> string(16) "get_forum_topics" ["class"]=> string(8) "Comments" ["object"]=> object(Comments)#23 (11) { ["time_control"]=> int(0) ["db"]=> object(ADODB_mysql)#2 (78) { ["databaseType"]=> string(5) "mysql" ["dataProvider"]=> string(5) "mysql" ["hasInsertID"]=> bool(true) ["hasAffectedRows"]=> bool(true) ["metaTablesSQL"]=> string(11) "SHOW TABLES" ["metaColumnsSQL"]=> string(20) "SHOW COLUMNS FROM %s" ["fmtTimeStamp"]=> string(13) "'Y-m-d H:i:s'" ["hasLimit"]=> bool(true) ["hasMoveFirst"]=> bool(true) ["hasGenID"]=> bool(true) ["isoDates"]=> bool(true) ["sysDate"]=> string(9) "CURDATE()" ["sysTimeStamp"]=> string(5) "NOW()" ["hasTransactions"]=> bool(false) ["forceNewConnect"]=> bool(false) ["poorAffectedRows"]=> bool(true) ["clientFlags"]=> int(0) ["substr"]=> string(9) "substring" ["nameQuote"]=> string(1) "`" ["_genIDSQL"]=> string(38) "update %s set id=LAST_INSERT_ID(id+1);" ["_genSeqSQL"]=> string(33) "create table %s (id int not null)" ["_genSeq2SQL"]=> string(26) "insert into %s values (%s)" ["_dropSeqSQL"]=> string(13) "drop table %s" ["database"]=> string(2) "le" ["host"]=> string(9) "localhost" ["user"]=> string(2) "le" ["password"]=> string(8) "bootlace" ["debug"]=> bool(false) ["maxblobsize"]=> int(262144) ["concat_operator"]=> string(1) "+" ["length"]=> string(6) "length" ["random"]=> string(6) "rand()" ["upperCase"]=> string(5) "upper" ["fmtDate"]=> string(7) "'Y-m-d'" ["true"]=> string(1) "1" ["false"]=> string(1) "0" ["replaceQuote"]=> string(2) "\'" ["charSet"]=> bool(false) ["metaDatabasesSQL"]=> string(0) "" ["uniqueOrderBy"]=> bool(false) ["emptyDate"]=> string(6) " " ["emptyTimeStamp"]=> string(6) " " ["lastInsID"]=> bool(false) ["hasTop"]=> bool(false) ["readOnly"]=> bool(false) ["genID"]=> int(0) ["raiseErrorFn"]=> string(16) "ADODB_Error_PEAR" ["cacheSecs"]=> int(3600) ["arrayClass"]=> string(18) "ADORecordSet_array" ["noNullStrings"]=> bool(false) ["numCacheHits"]=> int(0) ["numCacheMisses"]=> int(0) ["pageExecuteCountRows"]=> bool(true) ["uniqueSort"]=> bool(false) ["leftOuter"]=> bool(false) ["rightOuter"]=> bool(false) ["ansiOuter"]=> bool(false) ["autoRollback"]=> bool(false) ["fnExecute"]=> bool(false) ["fnCacheExecute"]=> bool(false) ["blobEncodeType"]=> bool(false) ["rsPrefix"]=> string(13) "ADORecordSet_" ["autoCommit"]=> bool(true) ["transOff"]=> int(0) ["transCnt"]=> int(0) ["fetchMode"]=> bool(false) ["_oldRaiseFn"]=> bool(false) ["_transOK"]=> NULL ["_connectionID"]=> resource(17) of type (mysql link) ["_errorMsg"]=> string(168) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `threadId` LIMIT 0,0' at line 10" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(false) ["_bindInputArray"]=> bool(false) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["databaseName"]=> string(2) "le" } ["buffer"]=> NULL ["flag"]=> NULL ["parser"]=> NULL ["pre_handlers"]=> array(0) { } ["pos_handlers"]=> array(0) { } ["postedit_handlers"]=> array(0) { } ["usergroups_cache"]=> array(0) { } ["num_queries"]=> int(0) ["now"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(4) { [0]=> &string(0) "" [1]=> &int(0) [2]=> &NULL [3]=> &NULL } } }